How can I edit multiple rows in a table or spreadsheet view?

Do the following:

  1. Select the first cell.
  2. Press and hold SHIFT while selecting another cell a few rows above or below.
  3. Type or select the value you want to use and press CTRL+Enter.
  4. The edited or selected value is applied to all selected cells.

These controls work like the multiselect and edit functionality in EXCEL.